SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Manchester NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:BETTER THAN NEW! EXQUISITE DETAILS, AN ENTERTAINER’S DELIGHT...THIS CUSTOM BEAUTY HAS IT ALL! Preeminently sited at the top of an exclusive cul-de-sac in a picturesque setting, you’ll fall in love with this elegant colonial. Manicured grounds and stepped stone walkway lead to a welcoming covered porch. Enter the two story foyer and notice crisp white millwork and thoughtful architectural touches. In one direction, French doors open to a home office beautifully appointed with built-in cabinetry. Opposite, a refined dining room flows seamlessly into the heart of the home, the chef’s kitchen. Guests will pull up a seat at the island for conversation and the cook will delight in abundant Shaker cabinetry, granite counters, extensive pantry and six burner stove for culinary creations. The party will naturally flow past the breakfast area to the great room with soaring ceilings beckoning guests to relax and settle into built-in bench seating that tastefully flanks the gas fireplace. Take in painterly panoramic sunsets and distant mountain views from the farmer’s porch before you unwind in the primary with ensuite bath to close out your day. Three additional bedrooms provide ample space for family and guests. The unfinished basement offers excellent storage and untapped room to create a home gym or home theater. Ideally located near city parks, dining, shopping and cultural attractions boasting easy highway access, this is gracious living! COME SEE THIS IMMACULATE HOME ON THE HILL!
Description:So much charm and character. Stroll along the tree lined sidewalks in the most desirable section of the north end. Wonderful neighborhood with turn of century homes all walking distance to the Stark and Livingston Parks, and downtown. This stately 4-5 bedroom, 6 bath colonial with grand foyer adorns hardwood floors, 2 staircases, large eat-in kitchen with granite and stainless appliances, walk in pantry, butlers pantry with additional sink and plenty of storage. The large formal dining can accommodate a large gathering, or cozy up to the wood burning fireplace in the living room. Another family room or office, and 1/2 bath complete the first floor. Most rooms feature crown moldings, wainscoting and built-in's. The switchback stairs off the grand foyer lead to the second floor where you'll find 4 large bedrooms, jack and Jill bathroom, 3/4 bath, primary suite with double closets, dressing room, and another 3/4 bath. The finished 3rd floor is perfect for the kids playroom, or au-pair suite with spacious sunny bedroom and full bath. If all that space wasn't enough, you can entertain in the finished lower level with bar area, wet sink, and vintage pool table freshly felted. Set up a showing now!